sisHYD User Guide

Output to Excel

Output to Excel or Standard report to Excel can be only used if MS Excel is installed or another application is linked with .xls files.

The data transfer path to Excel or another spreadsheet application is selected automatically. COM and XMLSS are available as transfer paths.

  • COM - This procedure is very time-consuming with larger reports.
    Note: Is only intended for older Microsoft Excel versions which do not support XMLSS. The reports are written directly into a new Excel file.
  • XMLSS - This procedure is much quicker, even with larger reports.
    • The report is stored as a file with the ending ‘.excel.xml’ in the project’s report directory. This file is opened with the application which is linked with ‘.xls’ files.
      Note: XMLSS stands for "eXtendable Markup Language for Spread Sheets" and is a standard for spreadsheet applications supported by many manufacturers.

Data transfer paths

  • Program – Data transfer
  • Microsoft Excel older than XP/2002 (version 10) – COM
  • Microsoft Excel XP/2002 (version 10) – XMLSS
  • Microsoft Excel 2003 (version 11) – XMLSS
  • Microsoft Excel Viewer 2003 – does not work
  • OpenOffice.Org 2.2 – XMLSS, if the application Calc is linked to the extension ‘.xls’